Skip to main content

ITOSS Database Backup and Restore

Backup​

pg_dump -Fc -f itossdb.sql itossdb

Restore​

Session started as user "postgres" and running the "psql" client.

CREATE DATABASE itossdb;
\c itossdb
CREATE EXTENSION IF NOT EXISTS timescaledb;
SELECT timescaledb_pre_restore();

\! pg_restore -Fc -d itossdb itossdb.sql
SELECT timescaledb_post_restore();